weather

Dataset statistics

Number of variables	15
Number of observations	420551
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	327
Duplicate rows (%)	0.1%
Total size in memory	48.1 MiB
Average record size in memory	120.0 B

Variable types

Categorical	1
Numeric	14

Alerts

Dataset has 327 (0.1%) duplicate rows	Duplicates
`Date Time` has a high cardinality: 420224 distinct values	High cardinality
`T (degC)` is highly overall correlated with `Tpot (K)` and 8 other fields	High correlation
`Tpot (K)` is highly overall correlated with `T (degC)` and 8 other fields	High correlation
`Tdew (degC)` is highly overall correlated with `T (degC)` and 6 other fields	High correlation
`rh (%)` is highly overall correlated with `T (degC)` and 3 other fields	High correlation
`VPmax (mbar)` is highly overall correlated with `T (degC)` and 8 other fields	High correlation
`VPact (mbar)` is highly overall correlated with `T (degC)` and 6 other fields	High correlation
`VPdef (mbar)` is highly overall correlated with `T (degC)` and 4 other fields	High correlation
`sh (g/kg)` is highly overall correlated with `T (degC)` and 6 other fields	High correlation
`H2OC (mmol/mol)` is highly overall correlated with `T (degC)` and 6 other fields	High correlation
`rho (g/m**3)` is highly overall correlated with `T (degC)` and 7 other fields	High correlation
`wv (m/s)` is highly overall correlated with `max. wv (m/s)`	High correlation
`max. wv (m/s)` is highly overall correlated with `wv (m/s)`	High correlation
`wv (m/s)` is highly skewed (γ1 = -152.7160913)	Skewed
`max. wv (m/s)` is highly skewed (γ1 = -144.7488651)	Skewed
`Date Time` is uniformly distributed	Uniform

Reproduction

Analysis started	2023-09-12 13:12:56.336156
Analysis finished	2023-09-12 13:13:22.459161
Duration	26.12 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Date Time
Categorical

HIGH CARDINALITY UNIFORM

Distinct	420224
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

21.03.2014 12:50:00	2
01.07.2010 03:50:00	2
01.07.2010 04:10:00	2
01.07.2010 04:20:00	2
01.07.2010 04:30:00	2
Other values (420219)	420541

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	7990469
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	419897 ?
Unique (%)	99.8%

Sample

1st row	01.01.2009 00:10:00
2nd row	01.01.2009 00:20:00
3rd row	01.01.2009 00:30:00
4th row	01.01.2009 00:40:00
5th row	01.01.2009 00:50:00

Common Values

Value	Count	Frequency (%)
21.03.2014 12:50:00	2	< 0.1%
01.07.2010 03:50:00	2	< 0.1%
01.07.2010 04:10:00	2	< 0.1%
01.07.2010 04:20:00	2	< 0.1%
01.07.2010 04:30:00	2	< 0.1%
01.07.2010 04:40:00	2	< 0.1%
01.07.2010 04:50:00	2	< 0.1%
01.07.2010 05:00:00	2	< 0.1%
01.07.2010 05:10:00	2	< 0.1%
01.07.2010 05:20:00	2	< 0.1%
Other values (420214)	420531	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
14:50:00	2922	0.3%
15:30:00	2922	0.3%
14:00:00	2922	0.3%
15:00:00	2922	0.3%
15:10:00	2922	0.3%
15:20:00	2922	0.3%
13:00:00	2922	0.3%
13:10:00	2922	0.3%
13:20:00	2922	0.3%
13:30:00	2922	0.3%
Other values (3055)	811882	96.5%

Most occurring characters

Value	Count	Frequency (%)
0	2600557	32.5%
1	1082312	13.5%
2	912743	11.4%
.	841102	10.5%
:	841102	10.5%
	420551	5.3%
3	273325	3.4%
5	234752	2.9%
4	233781	2.9%
6	163198	2.0%
Other values (3)	387046	4.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5887714	73.7%
Other Punctuation	1682204	21.1%
Space Separator	420551	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2600557	44.2%
1	1082312	18.4%
2	912743	15.5%
3	273325	4.6%
5	234752	4.0%
4	233781	4.0%
6	163198	2.8%
9	162674	2.8%
7	112228	1.9%
8	112144	1.9%

Other Punctuation

Value	Count	Frequency (%)
.	841102	50.0%
:	841102	50.0%

Space Separator

Value	Count	Frequency (%)
	420551	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	7990469	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2600557	32.5%
1	1082312	13.5%
2	912743	11.4%
.	841102	10.5%
:	841102	10.5%
	420551	5.3%
3	273325	3.4%
5	234752	2.9%
4	233781	2.9%
6	163198	2.0%
Other values (3)	387046	4.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7990469	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2600557	32.5%
1	1082312	13.5%
2	912743	11.4%
.	841102	10.5%
:	841102	10.5%
	420551	5.3%
3	273325	3.4%
5	234752	2.9%
4	233781	2.9%
6	163198	2.0%
Other values (3)	387046	4.8%

p (mbar)
Real number (ℝ)

Distinct	6117
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	989.21278

Minimum	913.6
Maximum	1015.35
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	913.6
5-th percentile	974.95
Q1	984.2
median	989.58
Q3	994.72
95-th percentile	1002.49
Maximum	1015.35
Range	101.75
Interquartile range (IQR)	10.52

Descriptive statistics

Standard deviation	8.3584807
Coefficient of variation (CV)	0.0084496287
Kurtosis	0.93352594
Mean	989.21278
Median Absolute Deviation (MAD)	5.25
Skewness	-0.40702279
Sum	4.1601442 × 10⁸
Variance	69.8642
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
990.96	469	0.1%
989.73	453	0.1%
991.08	447	0.1%
989.36	427	0.1%
991.2	415	0.1%
990.71	413	0.1%
989.48	409	0.1%
988.87	405	0.1%
990.59	401	0.1%
989.24	399	0.1%
Other values (6107)	416313	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
913.6	1	< 0.1%
914.1	1	< 0.1%
917.4	2	< 0.1%
918.3	1	< 0.1%
918.5	1	< 0.1%
942.43	1	< 0.1%
942.54	1	< 0.1%
942.58	1	< 0.1%
942.59	1	< 0.1%
942.62	1	< 0.1%

Value	Count	Frequency (%)
1015.35	1	< 0.1%
1015.3	1	< 0.1%
1015.29	2	< 0.1%
1015.28	1	< 0.1%
1015.26	1	< 0.1%
1015.23	1	< 0.1%
1015.21	1	< 0.1%
1015.2	1	< 0.1%
1015.19	1	< 0.1%
1015.17	3	< 0.1%

T (degC)
Real number (ℝ)

Distinct	5530
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.4501474

Minimum	-23.01
Maximum	37.28
Zeros	109
Zeros (%)	< 0.1%
Negative	55837
Negative (%)	13.3%
Memory size	3.2 MiB

Quantile statistics

Minimum	-23.01
5-th percentile	-3.86
Q1	3.36
median	9.42
Q3	15.47
95-th percentile	23.15
Maximum	37.28
Range	60.29
Interquartile range (IQR)	12.11

Descriptive statistics

Standard deviation	8.4233652
Coefficient of variation (CV)	0.8913475
Kurtosis	-0.20065837
Mean	9.4501474
Median Absolute Deviation (MAD)	6.06
Skewness	-0.01927229
Sum	3974268.9
Variance	70.953081
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.13	245	0.1%
5.2	238	0.1%
10.33	238	0.1%
8.59	238	0.1%
11.93	237	0.1%
12	235	0.1%
6.97	234	0.1%
10.4	234	0.1%
8.1	232	0.1%
5.53	231	0.1%
Other values (5520)	418189	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-23.01	1	< 0.1%
-22.91	1	< 0.1%
-22.76	1	< 0.1%
-22.64	1	< 0.1%
-22.63	1	< 0.1%
-22.55	2	< 0.1%
-22.54	1	< 0.1%
-22.5	1	< 0.1%
-22.49	2	< 0.1%
-22.47	1	< 0.1%

Value	Count	Frequency (%)
37.28	1	< 0.1%
37.13	1	< 0.1%
37.1	1	< 0.1%
37.09	1	< 0.1%
37.01	1	< 0.1%
36.87	3	< 0.1%
36.86	1	< 0.1%
36.79	1	< 0.1%
36.77	1	< 0.1%
36.71	1	< 0.1%

Tpot (K)
Real number (ℝ)

Distinct	5639
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	283.49274

Minimum	250.6
Maximum	311.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	250.6
5-th percentile	270.04
Q1	277.43
median	283.47
Q3	289.53
95-th percentile	297.26
Maximum	311.34
Range	60.74
Interquartile range (IQR)	12.1

Descriptive statistics

Standard deviation	8.5044714
Coefficient of variation (CV)	0.029998903
Kurtosis	-0.13967191
Mean	283.49274
Median Absolute Deviation (MAD)	6.05
Skewness	-0.042512193
Sum	1.1922316 × 10⁸
Variance	72.326034
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
282.69	223	0.1%
282.68	222	0.1%
281.46	220	0.1%
281.57	216	0.1%
282.2	215	0.1%
281.89	213	0.1%
282.66	213	0.1%
281.36	213	0.1%
288.6	211	0.1%
282.33	209	< 0.1%
Other values (5629)	418396	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
250.6	1	< 0.1%
250.71	1	< 0.1%
250.85	1	< 0.1%
250.98	1	< 0.1%
251.06	1	< 0.1%
251.09	1	< 0.1%
251.17	2	< 0.1%
251.18	1	< 0.1%
251.22	2	< 0.1%
251.23	1	< 0.1%

Value	Count	Frequency (%)
311.34	1	< 0.1%
311.21	1	< 0.1%
311.19	1	< 0.1%
311.06	1	< 0.1%
311.04	1	< 0.1%
311.02	1	< 0.1%
310.98	1	< 0.1%
310.97	1	< 0.1%
310.81	1	< 0.1%
310.78	1	< 0.1%

Tdew (degC)
Real number (ℝ)

Distinct	4343
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.9558538

Minimum	-25.01
Maximum	23.11
Zeros	216
Zeros (%)	0.1%
Negative	99829
Negative (%)	23.7%
Memory size	3.2 MiB

Quantile statistics

Minimum	-25.01
5-th percentile	-6.45
Q1	0.24
median	5.22
Q3	10.07
95-th percentile	15.14
Maximum	23.11
Range	48.12
Interquartile range (IQR)	9.83

Descriptive statistics

Standard deviation	6.7306743
Coefficient of variation (CV)	1.3581261
Kurtosis	-0.01879837
Mean	4.9558538
Median Absolute Deviation (MAD)	4.92
Skewness	-0.37711004
Sum	2084189.3
Variance	45.301977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.32	280	0.1%
8.13	278	0.1%
8.42	277	0.1%
8.47	275	0.1%
8.09	273	0.1%
8.46	272	0.1%
9.38	271	0.1%
8.27	267	0.1%
8.3	266	0.1%
9.22	265	0.1%
Other values (4333)	417827	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-25.01	1	< 0.1%
-24.85	1	< 0.1%
-24.8	1	< 0.1%
-24.71	1	< 0.1%
-24.66	1	< 0.1%
-24.63	1	< 0.1%
-24.61	1	< 0.1%
-24.58	1	< 0.1%
-24.55	1	< 0.1%
-24.52	1	< 0.1%

Value	Count	Frequency (%)
23.11	1	< 0.1%
23.07	1	< 0.1%
23.06	2	< 0.1%
22.94	2	< 0.1%
22.86	1	< 0.1%
22.83	1	< 0.1%
22.64	1	< 0.1%
22.4	1	< 0.1%
22.21	2	< 0.1%
22.2	2	< 0.1%

rh (%)
Real number (ℝ)

Distinct	4805
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.008259

Minimum	12.95
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	12.95
5-th percentile	44.105
Q1	65.21
median	79.3
Q3	89.4
95-th percentile	97.2
Maximum	100
Range	87.05
Interquartile range (IQR)	24.19

Descriptive statistics

Standard deviation	16.476175
Coefficient of variation (CV)	0.21676822
Kurtosis	-0.37445008
Mean	76.008259
Median Absolute Deviation (MAD)	11.5
Skewness	-0.67215791
Sum	31965350
Variance	271.46435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	1748	0.4%
90.5	1227	0.3%
94.8	1179	0.3%
93.9	1174	0.3%
90.6	1174	0.3%
90.2	1174	0.3%
90.1	1170	0.3%
94.2	1170	0.3%
88	1167	0.3%
90.9	1161	0.3%
Other values (4795)	408207	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12.95	1	< 0.1%
13.06	1	< 0.1%
13.52	1	< 0.1%
13.56	1	< 0.1%
13.88	2	< 0.1%
14.13	1	< 0.1%
14.2	1	< 0.1%
14.3	1	< 0.1%
14.44	1	< 0.1%
15.87	1	< 0.1%

Value	Count	Frequency (%)
100	1748	0.4%
99.9	396	0.1%
99.8	371	0.1%
99.7	442	0.1%
99.6	529	0.1%
99.5	550	0.1%
99.4	611	0.1%
99.3	621	0.1%
99.2	722	0.2%
99.1	768	0.2%

VPmax (mbar)
Real number (ℝ)

Distinct	3658
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.576251

Minimum	0.95
Maximum	63.77
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0.95
5-th percentile	4.59
Q1	7.78
median	11.82
Q3	17.6
95-th percentile	28.4
Maximum	63.77
Range	62.82
Interquartile range (IQR)	9.82

Descriptive statistics

Standard deviation	7.7390201
Coefficient of variation (CV)	0.57004105
Kurtosis	2.3970634
Mean	13.576251
Median Absolute Deviation (MAD)	4.64
Skewness	1.3110424
Sum	5709505.7
Variance	59.892431
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.83	420	0.1%
10.26	408	0.1%
10.64	406	0.1%
12.02	402	0.1%
10.86	397	0.1%
10.59	394	0.1%
10.22	390	0.1%
10.43	390	0.1%
11.94	389	0.1%
10.12	388	0.1%
Other values (3648)	416567	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.95	1	< 0.1%
0.96	1	< 0.1%
0.97	1	< 0.1%
0.98	2	< 0.1%
0.99	6	< 0.1%
1	6	< 0.1%
1.01	4	< 0.1%
1.02	4	< 0.1%
1.03	5	< 0.1%
1.05	3	< 0.1%

Value	Count	Frequency (%)
63.77	1	< 0.1%
63.26	1	< 0.1%
63.15	1	< 0.1%
63.12	1	< 0.1%
62.85	1	< 0.1%
62.37	3	< 0.1%
62.33	1	< 0.1%
62.1	1	< 0.1%
62.03	1	< 0.1%
61.83	1	< 0.1%

VPact (mbar)
Real number (ℝ)

Distinct	2438
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.5337559

Minimum	0.79
Maximum	28.32
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0.79
5-th percentile	3.76
Q1	6.21
median	8.86
Q3	12.35
95-th percentile	17.23
Maximum	28.32
Range	27.53
Interquartile range (IQR)	6.14

Descriptive statistics

Standard deviation	4.1841643
Coefficient of variation (CV)	0.4388789
Kurtosis	-0.24977824
Mean	9.5337559
Median Absolute Deviation (MAD)	2.94
Skewness	0.55660687
Sum	4009430.6
Variance	17.507231
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.92	560	0.1%
6.04	540	0.1%
6.03	538	0.1%
5.97	536	0.1%
6.08	536	0.1%
6	534	0.1%
6.09	534	0.1%
5.9	532	0.1%
5.84	531	0.1%
6.06	530	0.1%
Other values (2428)	415180	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.79	1	< 0.1%
0.8	1	< 0.1%
0.81	2	< 0.1%
0.82	4	< 0.1%
0.83	6	< 0.1%
0.84	9	< 0.1%
0.85	3	< 0.1%
0.86	3	< 0.1%
0.87	3	< 0.1%
0.88	1	< 0.1%

Value	Count	Frequency (%)
28.32	1	< 0.1%
28.26	1	< 0.1%
28.25	1	< 0.1%
28.24	1	< 0.1%
28.04	2	< 0.1%
27.9	1	< 0.1%
27.86	1	< 0.1%
27.53	1	< 0.1%
27.14	1	< 0.1%
26.83	1	< 0.1%

VPdef (mbar)
Real number (ℝ)

Distinct	3649
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0424116

Minimum	0
Maximum	46.01
Zeros	1749
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0.21
Q1	0.87
median	2.19
Q3	5.3
95-th percentile	14.32
Maximum	46.01
Range	46.01
Interquartile range (IQR)	4.43

Descriptive statistics

Standard deviation	4.8968509
Coefficient of variation (CV)	1.2113687
Kurtosis	7.3591571
Mean	4.0424116
Median Absolute Deviation (MAD)	1.63
Skewness	2.3654001
Sum	1700040.2
Variance	23.979149
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1749	0.4%
0.27	1477	0.4%
0.31	1465	0.3%
0.3	1460	0.3%
0.34	1444	0.3%
0.29	1435	0.3%
0.32	1424	0.3%
0.24	1407	0.3%
0.28	1406	0.3%
0.22	1396	0.3%
Other values (3639)	405888	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1749	0.4%
0.01	588	0.1%
0.02	536	0.1%
0.03	642	0.2%
0.04	742	0.2%
0.05	772	0.2%
0.06	950	0.2%
0.07	1047	0.2%
0.08	1078	0.3%
0.09	974	0.2%

Value	Count	Frequency (%)
46.01	1	< 0.1%
45.53	1	< 0.1%
45.42	1	< 0.1%
45.41	2	< 0.1%
45.2	1	< 0.1%
44.87	1	< 0.1%
44.83	1	< 0.1%
44.8	1	< 0.1%
44.76	1	< 0.1%
44.52	1	< 0.1%

sh (g/kg)
Real number (ℝ)

Distinct	1600
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0224083

Minimum	0.5
Maximum	18.13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0.5
5-th percentile	2.37
Q1	3.92
median	5.59
Q3	7.8
95-th percentile	10.92
Maximum	18.13
Range	17.63
Interquartile range (IQR)	3.88

Descriptive statistics

Standard deviation	2.656139
Coefficient of variation (CV)	0.44104267
Kurtosis	-0.22367576
Mean	6.0224083
Median Absolute Deviation (MAD)	1.86
Skewness	0.56790519
Sum	2532729.8
Variance	7.0550745
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.79	870	0.2%
3.8	861	0.2%
3.78	849	0.2%
3.77	848	0.2%
3.81	839	0.2%
3.85	828	0.2%
3.74	826	0.2%
3.92	808	0.2%
3.69	806	0.2%
3.82	802	0.2%
Other values (1590)	412214	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	2	< 0.1%
0.51	4	< 0.1%
0.52	10	< 0.1%
0.53	10	< 0.1%
0.54	4	< 0.1%
0.55	3	< 0.1%
0.56	3	< 0.1%
0.57	9	< 0.1%
0.58	20	< 0.1%
0.59	11	< 0.1%

Value	Count	Frequency (%)
18.13	1	< 0.1%
18.09	1	< 0.1%
18.07	2	< 0.1%
17.94	1	< 0.1%
17.93	1	< 0.1%
17.85	1	< 0.1%
17.82	1	< 0.1%
17.61	1	< 0.1%
17.36	1	< 0.1%
17.14	2	< 0.1%

H2OC (mmol/mol)
Real number (ℝ)

Distinct	2483
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.6402231

Minimum	0.8
Maximum	28.82
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0.8
5-th percentile	3.8
Q1	6.29
median	8.96
Q3	12.49
95-th percentile	17.44
Maximum	28.82
Range	28.02
Interquartile range (IQR)	6.2

Descriptive statistics

Standard deviation	4.2353948
Coefficient of variation (CV)	0.43934614
Kurtosis	-0.23590689
Mean	9.6402231
Median Absolute Deviation (MAD)	2.97
Skewness	0.56088997
Sum	4054205.5
Variance	17.938569
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.08	568	0.1%
6.09	558	0.1%
6.11	549	0.1%
6.06	547	0.1%
6.04	541	0.1%
6.13	535	0.1%
6.17	534	0.1%
5.91	519	0.1%
6.29	516	0.1%
6.18	511	0.1%
Other values (2473)	415173	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.8	1	< 0.1%
0.81	2	< 0.1%
0.82	2	< 0.1%
0.83	5	< 0.1%
0.84	7	< 0.1%
0.85	7	< 0.1%
0.86	5	< 0.1%
0.87	1	< 0.1%
0.88	2	< 0.1%
0.89	1	< 0.1%

Value	Count	Frequency (%)
28.82	1	< 0.1%
28.76	1	< 0.1%
28.74	1	< 0.1%
28.73	1	< 0.1%
28.53	1	< 0.1%
28.52	1	< 0.1%
28.39	1	< 0.1%
28.34	1	< 0.1%
28	1	< 0.1%
27.62	1	< 0.1%

rho (g/m**3)
Real number (ℝ)

Distinct	22972
Distinct (%)	5.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1216.0627

Minimum	1059.45
Maximum	1393.54
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1059.45
5-th percentile	1154.78
Q1	1187.49
median	1213.79
Q3	1242.77
95-th percentile	1282.33
Maximum	1393.54
Range	334.09
Interquartile range (IQR)	55.28

Descriptive statistics

Standard deviation	39.975208
Coefficient of variation (CV)	0.032872653
Kurtosis	0.13744658
Mean	1216.0627
Median Absolute Deviation (MAD)	27.53
Skewness	0.3127057
Sum	5.114164 × 10⁸
Variance	1598.0173
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1222.89	69	< 0.1%
1184.91	64	< 0.1%
1199.15	63	< 0.1%
1205.2	63	< 0.1%
1204.85	61	< 0.1%
1203.81	61	< 0.1%
1197.79	60	< 0.1%
1193.09	60	< 0.1%
1223.56	59	< 0.1%
1195.77	59	< 0.1%
Other values (22962)	419932	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1059.45	1	< 0.1%
1059.51	1	< 0.1%
1063.57	1	< 0.1%
1064.26	1	< 0.1%
1064.65	1	< 0.1%
1066.19	1	< 0.1%
1100.15	1	< 0.1%
1100.38	1	< 0.1%
1101.07	1	< 0.1%
1101.39	1	< 0.1%

Value	Count	Frequency (%)
1393.54	1	< 0.1%
1393.26	1	< 0.1%
1392.56	1	< 0.1%
1392.29	1	< 0.1%
1392.1	1	< 0.1%
1391.88	1	< 0.1%
1391.82	1	< 0.1%
1391.63	1	< 0.1%
1391.62	1	< 0.1%
1391.6	2	< 0.1%

wv (m/s)
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1193
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.7022238

Minimum	-9999
Maximum	28.49
Zeros	484
Zeros (%)	0.1%
Negative	18
Negative (%)	< 0.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	-9999
5-th percentile	0.41
Q1	0.99
median	1.76
Q3	2.86
95-th percentile	5.18
Maximum	28.49
Range	10027.49
Interquartile range (IQR)	1.87

Descriptive statistics

Standard deviation	65.446714
Coefficient of variation (CV)	38.447772
Kurtosis	23333.282
Mean	1.7022238
Median Absolute Deviation (MAD)	0.88
Skewness	-152.71609
Sum	715871.94
Variance	4283.2723
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.98	1631	0.4%
0.86	1619	0.4%
0.92	1616	0.4%
1.08	1605	0.4%
0.91	1588	0.4%
0.95	1575	0.4%
0.79	1564	0.4%
0.84	1563	0.4%
1.06	1560	0.4%
0.72	1559	0.4%
Other values (1183)	404671	96.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	18	< 0.1%
0	484	0.1%
0.01	69	< 0.1%
0.02	58	< 0.1%
0.03	71	< 0.1%
0.04	74	< 0.1%
0.05	63	< 0.1%
0.06	56	< 0.1%
0.07	68	< 0.1%
0.08	55	< 0.1%

Value	Count	Frequency (%)
28.49	1	< 0.1%
14.63	1	< 0.1%
14.09	1	< 0.1%
14.01	1	< 0.1%
13.95	1	< 0.1%
13.64	1	< 0.1%
13.59	1	< 0.1%
13.5	1	< 0.1%
13.19	1	< 0.1%
13.09	1	< 0.1%

max. wv (m/s)
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1503
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0565553

Minimum	-9999
Maximum	23.5
Zeros	435
Zeros (%)	0.1%
Negative	20
Negative (%)	< 0.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	-9999
5-th percentile	0.84
Q1	1.76
median	2.96
Q3	4.74
95-th percentile	8.09
Maximum	23.5
Range	10022.5
Interquartile range (IQR)	2.98

Descriptive statistics

Standard deviation	69.016932
Coefficient of variation (CV)	22.579972
Kurtosis	20974.474
Mean	3.0565553
Median Absolute Deviation (MAD)	1.38
Skewness	-144.74887
Sum	1285437.4
Variance	4763.3369
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.88	4273	1.0%
2	3975	0.9%
1.64	3371	0.8%
1.76	3347	0.8%
2.88	3308	0.8%
1.52	3287	0.8%
0.88	3285	0.8%
1.68	3243	0.8%
1.36	3240	0.8%
1.92	3240	0.8%
Other values (1493)	385982	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	20	< 0.1%
0	435	0.1%
0.13	83	< 0.1%
0.2	4	< 0.1%
0.22	1	< 0.1%
0.24	21	< 0.1%
0.25	127	< 0.1%
0.26	10	< 0.1%
0.28	50	< 0.1%
0.3	17	< 0.1%

Value	Count	Frequency (%)
23.5	1	< 0.1%
22.86	1	< 0.1%
22.26	1	< 0.1%
21.58	1	< 0.1%
20.99	1	< 0.1%
20.78	1	< 0.1%
20.69	1	< 0.1%
20.58	1	< 0.1%
20.49	1	< 0.1%
20.4	1	< 0.1%

wd (deg)
Real number (ℝ)

Distinct	9893
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	174.74374

Minimum	0
Maximum	360
Zeros	436
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	20.39
Q1	124.9
median	198.1
Q3	234.1
95-th percentile	289.9
Maximum	360
Range	360
Interquartile range (IQR)	109.2

Descriptive statistics

Standard deviation	86.681693
Coefficient of variation (CV)	0.49605035
Kurtosis	-0.62746528
Mean	174.74374
Median Absolute Deviation (MAD)	46.5
Skewness	-0.49202149
Sum	73488654
Variance	7513.7159
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
211.2	471	0.1%
209.3	457	0.1%
209.7	450	0.1%
208.7	450	0.1%
212	448	0.1%
210.4	446	0.1%
211.8	444	0.1%
210.9	443	0.1%
211.5	443	0.1%
211.1	441	0.1%
Other values (9883)	416058	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	436	0.1%
0.01	3	< 0.1%
0.02	8	< 0.1%
0.03	7	< 0.1%
0.04	6	< 0.1%
0.05	9	< 0.1%
0.06	4	< 0.1%
0.07	5	< 0.1%
0.08	6	< 0.1%
0.09	2	< 0.1%

Value	Count	Frequency (%)
360	24	< 0.1%
359.9	46	< 0.1%
359.8	71	< 0.1%
359.7	49	< 0.1%
359.6	58	< 0.1%
359.5	44	< 0.1%
359.4	59	< 0.1%
359.3	46	< 0.1%
359.2	56	< 0.1%
359.1	52	< 0.1%

Auto

Heatmap
Table

	p (mbar)	T (degC)	Tpot (K)	Tdew (degC)	rh (%)	VPmax (mbar)	VPact (mbar)	VPdef (mbar)	sh (g/kg)	H2OC (mmol/mol)	rho (g/m**3)	wv (m/s)	max. wv (m/s)	wd (deg)
p (mbar)	1.000	-0.055	-0.129	-0.071	-0.002	-0.055	-0.071	-0.028	-0.087	-0.087	0.296	-0.193	-0.185	-0.052
T (degC)	-0.055	1.000	0.997	0.899	-0.538	1.000	0.899	0.799	0.898	0.898	-0.963	0.088	0.122	0.053
Tpot (K)	-0.129	0.997	1.000	0.897	-0.535	0.997	0.897	0.795	0.898	0.898	-0.982	0.103	0.136	0.056
Tdew (degC)	-0.071	0.899	0.897	1.000	-0.162	0.899	1.000	0.500	1.000	1.000	-0.878	-0.063	-0.046	0.041
rh (%)	-0.002	-0.538	-0.535	-0.162	1.000	-0.538	-0.162	-0.925	-0.161	-0.161	0.499	-0.346	-0.391	-0.065
VPmax (mbar)	-0.055	1.000	0.997	0.899	-0.538	1.000	0.899	0.799	0.898	0.898	-0.963	0.088	0.122	0.053
VPact (mbar)	-0.071	0.899	0.897	1.000	-0.162	0.899	1.000	0.500	1.000	1.000	-0.878	-0.063	-0.046	0.041
VPdef (mbar)	-0.028	0.799	0.795	0.500	-0.925	0.799	0.500	1.000	0.500	0.500	-0.756	0.277	0.323	0.080
sh (g/kg)	-0.087	0.898	0.898	1.000	-0.161	0.898	1.000	0.500	1.000	1.000	-0.882	-0.060	-0.043	0.041
H2OC (mmol/mol)	-0.087	0.898	0.898	1.000	-0.161	0.898	1.000	0.500	1.000	1.000	-0.882	-0.060	-0.043	0.041
rho (g/m**3)	0.296	-0.963	-0.982	-0.878	0.499	-0.963	-0.878	-0.756	-0.882	-0.882	1.000	-0.127	-0.157	-0.059
wv (m/s)	-0.193	0.088	0.103	-0.063	-0.346	0.088	-0.063	0.277	-0.060	-0.060	-0.127	1.000	0.958	-0.015
max. wv (m/s)	-0.185	0.122	0.136	-0.046	-0.391	0.122	-0.046	0.323	-0.043	-0.043	-0.157	0.958	1.000	0.034
wd (deg)	-0.052	0.053	0.056	0.041	-0.065	0.053	0.041	0.080	0.041	0.041	-0.059	-0.015	0.034	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Date Time	p (mbar)	T (degC)	Tpot (K)	Tdew (degC)	rh (%)	VPmax (mbar)	VPact (mbar)	VPdef (mbar)	sh (g/kg)	H2OC (mmol/mol)	rho (g/m**3)	wv (m/s)	max. wv (m/s)	wd (deg)
0	01.01.2009 00:10:00	996.52	-8.02	265.40	-8.90	93.3	3.33	3.11	0.22	1.94	3.12	1307.75	1.03	1.75	152.3
1	01.01.2009 00:20:00	996.57	-8.41	265.01	-9.28	93.4	3.23	3.02	0.21	1.89	3.03	1309.80	0.72	1.50	136.1
2	01.01.2009 00:30:00	996.53	-8.51	264.91	-9.31	93.9	3.21	3.01	0.20	1.88	3.02	1310.24	0.19	0.63	171.6
3	01.01.2009 00:40:00	996.51	-8.31	265.12	-9.07	94.2	3.26	3.07	0.19	1.92	3.08	1309.19	0.34	0.50	198.0
4	01.01.2009 00:50:00	996.51	-8.27	265.15	-9.04	94.1	3.27	3.08	0.19	1.92	3.09	1309.00	0.32	0.63	214.3
5	01.01.2009 01:00:00	996.50	-8.05	265.38	-8.78	94.4	3.33	3.14	0.19	1.96	3.15	1307.86	0.21	0.63	192.7
6	01.01.2009 01:10:00	996.50	-7.62	265.81	-8.30	94.8	3.44	3.26	0.18	2.04	3.27	1305.68	0.18	0.63	166.5
7	01.01.2009 01:20:00	996.50	-7.62	265.81	-8.36	94.4	3.44	3.25	0.19	2.03	3.26	1305.69	0.19	0.50	118.6
8	01.01.2009 01:30:00	996.50	-7.91	265.52	-8.73	93.8	3.36	3.15	0.21	1.97	3.16	1307.17	0.28	0.75	188.5
9	01.01.2009 01:40:00	996.53	-8.43	264.99	-9.34	93.1	3.23	3.00	0.22	1.88	3.02	1309.85	0.59	0.88	185.0

	Date Time	p (mbar)	T (degC)	Tpot (K)	Tdew (degC)	rh (%)	VPmax (mbar)	VPact (mbar)	VPdef (mbar)	sh (g/kg)	H2OC (mmol/mol)	rho (g/m**3)	wv (m/s)	max. wv (m/s)	wd (deg)
420541	31.12.2016 22:30:00	1000.44	-4.08	269.05	-7.89	74.60	4.51	3.37	1.15	2.10	3.37	1293.55	1.27	2.48	192.1
420542	31.12.2016 22:40:00	1000.45	-4.45	268.68	-7.15	81.30	4.39	3.57	0.82	2.22	3.57	1295.24	0.80	1.44	183.8
420543	31.12.2016 22:50:00	1000.32	-4.09	269.05	-7.23	78.60	4.51	3.54	0.96	2.21	3.54	1293.37	1.25	1.60	199.2
420544	31.12.2016 23:00:00	1000.21	-3.76	269.39	-7.95	72.50	4.62	3.35	1.27	2.09	3.35	1291.71	0.89	1.30	223.7
420545	31.12.2016 23:10:00	1000.11	-3.93	269.23	-8.09	72.60	4.56	3.31	1.25	2.06	3.31	1292.41	0.56	1.00	202.6
420546	31.12.2016 23:20:00	1000.07	-4.05	269.10	-8.13	73.10	4.52	3.30	1.22	2.06	3.30	1292.98	0.67	1.52	240.0
420547	31.12.2016 23:30:00	999.93	-3.35	269.81	-8.06	69.71	4.77	3.32	1.44	2.07	3.32	1289.44	1.14	1.92	234.3
420548	31.12.2016 23:40:00	999.82	-3.16	270.01	-8.21	67.91	4.84	3.28	1.55	2.05	3.28	1288.39	1.08	2.00	215.2
420549	31.12.2016 23:50:00	999.81	-4.23	268.94	-8.53	71.80	4.46	3.20	1.26	1.99	3.20	1293.56	1.49	2.16	225.8
420550	01.01.2017 00:00:00	999.82	-4.82	268.36	-8.42	75.70	4.27	3.23	1.04	2.01	3.23	1296.38	1.23	1.96	184.9

Most frequently occurring

	Date Time	p (mbar)	T (degC)	Tpot (K)	Tdew (degC)	rh (%)	VPmax (mbar)	VPact (mbar)	VPdef (mbar)	sh (g/kg)	H2OC (mmol/mol)	rho (g/m**3)	wv (m/s)	max. wv (m/s)	wd (deg)	# duplicates
0	01.07.2010 00:10:00	992.06	17.87	291.69	14.06	78.4	20.50	16.07	4.43	10.14	16.20	1180.21	0.31	0.56	51.11	2
1	01.07.2010 00:20:00	992.02	17.82	291.65	14.03	78.5	20.44	16.04	4.39	10.12	16.17	1180.38	0.23	0.48	52.64	2
2	01.07.2010 00:30:00	992.04	17.92	291.75	14.09	78.3	20.57	16.10	4.46	10.16	16.23	1179.97	0.18	0.40	22.10	2
3	01.07.2010 00:40:00	991.96	17.82	291.65	14.02	78.4	20.44	16.02	4.41	10.11	16.15	1180.32	0.19	0.40	354.80	2
4	01.07.2010 00:50:00	991.90	17.54	291.38	13.96	79.5	20.08	15.96	4.12	10.07	16.10	1181.41	0.24	0.98	21.40	2
5	01.07.2010 01:00:00	991.81	17.35	291.19	13.87	80.0	19.84	15.87	3.97	10.02	16.00	1182.12	0.44	0.96	49.64	2
6	01.07.2010 01:10:00	991.81	17.11	290.95	13.83	81.0	19.54	15.83	3.71	9.99	15.96	1183.11	0.34	0.76	296.10	2
7	01.07.2010 01:20:00	991.85	16.90	290.74	13.74	81.6	19.28	15.74	3.55	9.93	15.87	1184.06	1.21	1.76	239.50	2
8	01.07.2010 01:30:00	991.82	16.87	290.71	13.61	81.1	19.25	15.61	3.64	9.85	15.74	1184.21	1.75	2.28	222.20	2
9	01.07.2010 01:40:00	991.81	16.69	290.53	13.59	81.9	19.03	15.58	3.44	9.83	15.71	1184.94	1.04	1.64	209.90	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring